Content starts here Add an External Function to an Existing Physical Data Service
This page last changed on Feb 26, 2008.

How To Add an External Function to a Existing Physical Data Service

You can add qualified external operations (functions and procedures) from the same data source to existing physical data services based on:

  • Relational
  • Web service
  • Java functions

This is a very convenient way of enhancing a data service based on changes in underlying data or other business needs.
The steps involved in adding an external function to a qualified data service are:

  1. Open the data service in Project Explorer.
  2. Select Overview mode.
  3. Right click > Add External Function...
  4. A wizard appropriate to the data service type will appear. Complete the steps as you would when creating a data service. For example, select from the set of currently unselected operations in the WSDL that underlies a web service-based data service.
Adding an External Function to a Data Service

External operations cannot be added to physical data services based on:

  • XML data
  • Delimited data
Qualified Operation and Physical Data Service Type Matrix
Artifact
Physical Data Service Type
Comment
Operation Web Service
Only visible operations will be from the WSDL that underlies the physical data service.
Function
Java
Only functions from the Java class defined by the underlying data service will be visible.
Stored Procedure Relational
Only stored procedures from the same data source defined by the underlying data service will be visible.
SQL Statement
Relational
Query must be to the same database as that underlying the data service.



Additional Constraints

  • Table-based functions cannot be added to data services.
  • Only library operations can be added to library data services.
  • Read or primary create-update-delete functions can be added to entity data services as long as the entity data services constraints are not violated.
Document generated by Confluence on Apr 28, 2008 15:54